DROP TABLE ICC_XDECK;
GO
CREATE TABLE "INTEX"."ICC_XDECK"
(
"MANDANT" VARCHAR2(2 CHAR),
"ART" VARCHAR2(20 CHAR),
"VAR" VARCHAR2(3 CHAR),
"COLOR" VARCHAR2(10 CHAR),
        "ASIZE" VARCHAR2(7 CHAR),
        "UM" VARCHAR2(3 CHAR),
        "CDES" VARCHAR2(60 CHAR),
        "ARTDES" VARCHAR2(60 CHAR),
        "REQ" NUMBER(20,3),
        "SELLER" VARCHAR2(10 CHAR),
		"SELLERNAME" VARCHAR2(40 CHAR),
        "REMARK" VARCHAR2(60 CHAR)
   ) SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "DATA"
GO
